Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
WorkerID (FK)(PK) | A unique system-assigned identifier for the Person who is a particular Worker. | ID_WRKR | Identity | integer | Worker(PA_WRKR) |
ReturnTotalAmount | The total monetary amount of refunds made for ITEMs originally purchased as part of an EMPLOYEE discount scheme in each REPORTING PERIOD. | MO_RTN_TOT_EM_DSC | Money | decimal(16,5) | |
TotalTransactionCount | The total number of transactions involving EMPLOYEE purchases in a given REPORTING PERIOD. | QU_TRN_TOT_EM_DSC | QuantityTransactionCount | decimal(7,0) | |
TotalMiscellaneousFeeCount | The total number of miscellaneous fees discounted for EMPLOYLEEs in each REPORTING PERIOD. | QU_FE_MSC_TOT_EM | QuantityTransactionCount | decimal(7,0) | |
MiscellaneousFeeTotalAmount | The total monetary amount of discount granted to EMPLOYEEs for miscellaneous fees in each REPORTING PERIOD. | MO_FE_MSC_EM_DSC | Money | decimal(16,5) | |
NetSalesTotalAmount | The total monetary amount of net sales resulting from EMPLOYEE purchases in each REPORTING PERIOD. | MO_SLS_NT_EM_DSC | Money | decimal(16,5) | |
LineItemCount | The total number of ITEMs discounted as part of EMPLOYEE purchases in each REPORTING PERIOD. | QU_ITM_LN_EM_DSC | QuantityTransactionCount | decimal(7,0) | |
TotalAmount | The total monetary amount of discount granted in EMPLOYEE purchases in each REPORTING PERIOD. | MO_SLS_TOT_EM_DSC | Money | decimal(16,5) | |
TotalRefundCount | The total number of refunds made for ITEMs originally purchased as part of an EMPLOYEE discount scheme in each REPORTING PERIOD. | QU_RFD_TOT_EM_DSC | QuantityTransactionCount | decimal(7,0) | |
RefundTotalAmount | The total number of refunds made for ITEMs originally purchased as part of an EMPLOYEE discount scheme in each REPORTING PERIOD. | MO_RFD_TOT_EM_DSC | Money | decimal(16,5) | |
TotalReturnCount | The total number of returns of ITEMs originally purchased as part of an EMPLOYEE discount scheme in each REPORTING PERIOD. | QU_RTN_TOT_EM_DSC | QuantityTransactionCount | decimal(7,0) | |